from openpyxl import load_workbook
wb = load_workbook("test2.xlsx")
print(type(wb.worksheets))
ws = wb.worksheets[0]
rows = ws.max_row
cols = ws.max_column

# 将表格中的所有内容提取成一个list
L = []
for r in range(1,rows+1):
    temp =[]
    for c in range(1,cols+1):
        cell = ws.cell(row=r,column=c).value
        temp.append(cell)
    L.append(temp)
print(L)
